Alteryx Academy

  Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by [First and Last Name], [@Community User Name]. Thank you, [First Name] for your submission!   In this week’s challenge, you apply your skills with formulas, macros, and analytic apps to simulate a basic probability experiment: flipping a coin. This challenge helps you practice building iterative logic and user-driven apps in Alteryx Designer.   Here are the steps you need to follow to build the flip-coin app:   Create an Iterative Macro (`Coin Flip Macro.yxmc`) that repeats the coin flip simulation for a specified number of times. This macro should: Initialize with a Text Input containing iterations, head count and tail count. Update the counts on each iteration. Use a condition to stop once the iteration count reaches the user-specified total. Once the macro is created, build the analytic app that does the following: Prompts the user with a Text Box question: "How Many Coin Flips?" Passes this input into the macro to determine the number of simulations it runs. Displays how many times "Heads" and "Tails" occurred.   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Download Start File ... View more

  Hello Community members,   A solution to last week’s challenge can be found here.    This week’s challenge was submitted by Talia Sanders (@tsand22) . Thank you, Talia, for this incredible challenge!   Every year, parents and guardians need to purchase school supplies for their children at the beginning of the school year. This is a major cost that many families struggle to budget for.   In Part 1 of this challenge, your objective is to calculate the cost of school supplies for one child in each grade of elementary school (from kindergarten to sixth grade).   There are two datasets provided: School Supply List Text Input: A list of school supplies separated by grade. Cost of School Supplies Text Input: The cost of each unit from a list of school supplies.   Need a refresher? Review the following lessons in Academy to gear up: Changing Data Layouts Sorting Data   Ready? Good luck! The Academy Team   Download Start File   Download Solution File   Data Source: https://www.in.gov/doe/it/data-center-and-reports/ ... View more

Hello Community Members!   A solution to last week’s challenge can be found here.   It's time to put your spatial skills to the test again! This challenge, submitted by Claire McCollough (@clmc9601), will challenge you to use the Designer Spatial palette efficiently.   You are provided with two datasets. The first dataset contains polygons representing the counties of Maine, a state in the USA. The second dataset contains a polygon representing the Gulf of Maine, located in the nearby waters of the Atlantic Ocean.   Your tasks are to: Identify which Maine county has the longest coastline on the Gulf of Maine. (Exclude any islands smaller than 5 kilometers.) Determine which county has the most small islands. (An island is considered small if it is less than 5 square kilometers.) Need a refresher? Review the Spatial Analytics lessons in Academy to gear up.   Happy solving!   The Academy Team ... View more

  Hi Maveryx,   A solution to last week’s challenge can be found here.    This challenge was submitted by our ACE and an active member in the Alteryx Community, Ippei Nakagawa (@gawa)  . Thank you Gawa for your contribution and we look forward to the next ones that you may bring to the table!   Across the United States, an annular solar eclipse was observed on October 14, 2023, and a total solar eclipse will be observed on April 8, 2024. In this challenge, you will determine which lucky cities in the USA observed an annular solar eclipse in 2023 and which ones will observe the total solar eclipse in 2024, as well as one lucky city that will observe both! The provided datasets include solar eclipse information from 2023 and 2024 including the name of the city; latitude and longitude of the city; how long the eclipse will last; and the eclipse’s category (P: partial, T: total, A: annual).   Your tasks: Create a combined list of the cities that observed the annular eclipse in 2023 and which cities will observe the total eclipse in 2024. Create a map to visualize each eclipse’s path throughout the year for 2023 and 2024. Determine the lucky city that will get to see both eclipses!   Hint: The provided datasets are JSON files. To facilitate the data extraction, use the Parse JSON tool in the Developer tab of Designer.   Need a refresher? Review these lessons in Academy to gear up:   Changing Data Layouts Parsing JSON Creating Spatial Objects   Sources: https://svs.gsfc.nasa.gov/ https://svs.gsfc.nasa.gov/vis/a000000/a005000/a005073/2023_city_times.json https://svs.gsfc.nasa.gov/vis/a000000/a005000/a005073/2024_city_times.json   Good luck!   ... View more

  Hi Maveryx,   A solution to last week’s challenge can be found here.   Roland (@RWvanLeeuwen)  submitted this challenge as a follow-on to our Valentine’s Day spatial challenge, and solving it now is a great way to celebrate summer in the northern hemisphere. Thank you, Roland, for submitting another great challenge!   In Challenge #413 you applied your data analytics skills to help your friends visit as many ice cream shops as possible, including those that served a particular ice cream flavor. However, your friends are now worried about all the caloric intake, and for the next road trip they want to add some balance by focusing on store locations that are somewhat clustered together so you can all ride your bicycles to the ice cream shops instead!   Note: This challenge helps us check whether a group of shops might be located on the border of multiple states. We need to eliminate the limitation that the closest stores have to be located in the same state. Additionally, the bike ride you and your friends plan to take has specific distance parameters that you all believe will work best.   Your tasks for this challenge: Create grids with cells that are 1 mile in size, and for each grid, find the 100 nearest ice cream shops within a 40-mile radius. Select the grid cells that have at least 10 ice cream shops. Select the 100 grid cells with the lowest average distance between the shops and the grid cell location.   Need a refresher? Review the following lessons in Academy to gear up: Spatial Analytics Summarizing Data   Good luck!     ... View more